County Profile for Franklin - 2014



County Controls Information

Cost Report Counts Population
Total Hospital Count 2 Total Population on July 31, 2014 0
Total Cost Reports Filed in 2014 4 Total Births 0
Total Cost Reports Submitted 0 Total Deaths 0
Total Cost Reports Settled 4 Net Population Natural Change 0
Total Cost Reports Reopened 0 Total International Migration 0
Total Cost Reports Ammended 0 Total Domestic Migration 0
Total Cost Reports Audited 0 Total Residual 0
Net Population Change 0

County Financial Statements - Worksheet G

Balance Sheet Income Statement
Current Assets 15,080,015 Total Charges 199,617,610
Fixed Assets 32,438,543 Contract Allowance 110,981,954
Other Assets 4,900,738 Operating Revenue 88,635,656
Total Assets 52,419,296 Operating Expenses 97,960,895
Current Liabilities 7,193,304 Operating Margin -9,325,239
Long Term Liabilities 21,356,957 Other Income -3,621,305
Total Equity 23,869,035 Other Expense 51
Total Liabilities and Equity 52,419,296 Net Profit or Loss -12,946,595

County Calculations

Per Discharge Statistics Per Bed Statistics Per Person Statistics
Revenue per Discharge $34,435 Revenue per Bed $2,014,447 Revenue per Person $88,635,656
Net Margin per Discharge ($3,623) Net Margin per Bed ($211,937) Net Margin per Person ($9,325,239)
Net Profit per Discharge ($5,030) Net Profit per Bed ($294,241) Net Profit per Person ($12,946,595)
Net Fixed Assets per Discharge $12,602 Net Fixed Assets per Bed $737,240 Net Fixed Assets per Bed $32,438,543
Long Term Debt per Discharge $8,297 Long Term Debt per Bed $485,385 Long Term Debt per Person $21,356,957
Persons per Discharge 0 Persons per Bed 0
Occupancy Rate 44.3 %
Length of Stay 4 Days

County Ranking of Selected Values

Income Statement Balance Sheet Statistics
Total Charges 1,045 Net Fixed Assets 1,111 Population Estimate 1,151
Total Revenue 951 Long Term Liabilities 970 Total Patient Discharges 1,096
Net Margin 2,896 Total Patient Beds 1,417
Net Profit or Loss 3,178

County Charges and Direct Cost - Worksheet B and C

Line Description Direct Cost Charges Ratio
30 Adults and Pediatrics - General Routine Care 8,922,862 16,452,693 0.5423
31 Intensive Care Unit 1,676,539 2,506,181 0.6690
32 Coronary Care Unit 0 0
43 Nursery 868,340 1,186,827 0.7316
44 Skilled Nursing Care 0 0
50 Operating Room 7,836,616 21,444,131 0.3654
51 Recovery Room 0 0
52 Labor and Delivery Room 316,393 390,867 0.8095

County General Service Cost - Worksheet A

Lines Description Amount Lines Description Amount
01 Capital Related - Building and Fixtures 3,992,774 13 Nursing Administration 641,259
02,03 Captial Related - Movable Equipment 1,942,133 14 Central Services and Supply 476,974
04 Employee Benefits 8,582,095 15 Pharmacy 1,545,039
05 Administrative and General 12,817,054 16 Medical Records and Medical Library 1,059,097
06 Maintenance and Repairs 1,485,715 17 Social Services 156,856
07 Operation of Plant 1,424,863 18 Other General Service Expense 0
08,09 Laundry, Linen and Housekeeping 1,189,290 19 Non Physician Anesthetist 0
10,11 Dietary and Cafeteria 798,002 20,21,22,23 Education Programs 0
Total General Service Cost Centers 36,111,151

County Profile for Franklin - 2014